UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UhL0KgaodRe5aP16+We9cgqpVcaJURLfOjJFGC6LjSQ='
WHERE
key_id = '1f42267c851806755655c0ed353777477bd175239ffc278bb31394583ab2affe'
AND (
token = 'UhL0KgaodRe5aP16+We9cgqpVcaJURLfOjJFGC6LjSQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)