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