UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xRoKOg2/CNagLQwMik5e5EMkMo9nO0xrFCbkTGbSeHI='
WHERE
key_id = '78ec1e8a490be938c29df6a9cdc507071e1aacbf4152ad2bef2c484ea2f1223e'
AND (
token = 'xRoKOg2/CNagLQwMik5e5EMkMo9nO0xrFCbkTGbSeHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)