UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCkrJWkUspQ+x+M/K/+OeNX9fBFB3vPgyV71bKesC6Y='
WHERE
key_id = '1a182c333d01539d4c532253c64e1993238c560e298d205a55887827dbe3abcb'
AND (
token = 'QCkrJWkUspQ+x+M/K/+OeNX9fBFB3vPgyV71bKesC6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)