UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BXDnKVVRfPKQdmjhMC5fgrelZ9EGGmfcf54Ouv0SyLU='
WHERE
key_id = 'af59588452c52dc833d18ae4057ee7443b54022448e4f7eab3e0883f96d0a3f9'
AND (
token = 'BXDnKVVRfPKQdmjhMC5fgrelZ9EGGmfcf54Ouv0SyLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)