UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GkYs5JNvSfSVJce2rSQCOV4+B5teVkQL3aObf1OvDRQ='
WHERE
key_id = '41001c9a2ab76d414cb8cef0dc429bec17538db45794f37c88f3d667252f6ceb'
AND (
token = 'GkYs5JNvSfSVJce2rSQCOV4+B5teVkQL3aObf1OvDRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)