UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kn/YpZjB4OC6B9UYClsyRyyV0S9M2OBnIzUDEnQgXyQ='
WHERE
key_id = '40fc008ab364d9b83022be7f7a1d05c438965cedf15f0636ba5015182a7d29f1'
AND (
token = 'kn/YpZjB4OC6B9UYClsyRyyV0S9M2OBnIzUDEnQgXyQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)