UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TUEYgth4wbJ6eB9yb6BJ9wQvLM53kpA/ipaxitu6vZ8='
WHERE
key_id = 'd31e8ef64daa1769b3af0882f4a727c8bf810bb24d7829302c96f14df72e012e'
AND (
token = 'TUEYgth4wbJ6eB9yb6BJ9wQvLM53kpA/ipaxitu6vZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)