UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XWhJoCHTCk2dT4s5jXxGhZ0Unq+4p6VuKmXu5j/Oq20='
WHERE
key_id = 'bf927242b836f8590a140366907e566c0cf2d8eac9a5f4673a41f50e1811c60d'
AND (
token = 'XWhJoCHTCk2dT4s5jXxGhZ0Unq+4p6VuKmXu5j/Oq20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)