UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/8YyJCqrKAccVHd98+XU+AQfXWRQpvBUtS7xxnMS4wI='
WHERE
key_id = 'd5e598438a6b5ed50ad97906661efd97275aec9038abc5564e4fc659a505309e'
AND (
token = '/8YyJCqrKAccVHd98+XU+AQfXWRQpvBUtS7xxnMS4wI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)