UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ko7xhbrEVxgrLfTzyYIv9mjKakDc5vS7UY2A0qd8G9w='
WHERE
key_id = 'f6642a805144f63b1043bcd997792222576527346ef46cb0db6c409783b159ac'
AND (
token = 'Ko7xhbrEVxgrLfTzyYIv9mjKakDc5vS7UY2A0qd8G9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)