UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'riwsKi6gbhBKvK0YPdXI8uB4/QFcnBBiYVI8VYogJuU='
WHERE
key_id = '8c573c1acfcd652b15697d1b35acb7a0a0d5efc3ec00740f3d44767cc49e2265'
AND (
token = 'riwsKi6gbhBKvK0YPdXI8uB4/QFcnBBiYVI8VYogJuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)