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