UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ko1/bqGKV/9Nx5CKgkLB2UeIfrP/pwg5Cw+w7NKrOu8='
WHERE
key_id = 'e4c517ed5d4b95d37a0311c636b0690f0e0d790e1698036acbfdb5ee9529917e'
AND (
token = 'Ko1/bqGKV/9Nx5CKgkLB2UeIfrP/pwg5Cw+w7NKrOu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)