UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U7hDXb8cSHTGmqObSLfTS6CtWSOdE2urciFPo/qTSi8='
WHERE
key_id = 'fd9a73f3877cfcf05180254215fd00655d44f8b445b4d9189660a09068177598'
AND (
token = 'U7hDXb8cSHTGmqObSLfTS6CtWSOdE2urciFPo/qTSi8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)