UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1nd3ESyJzYoW/wYvEMPXh1FHzK6/RgsE3m1w7atVrf8='
WHERE
key_id = '75debe9f2c71a2f91b3143510c5677938a7931da227c964d03b7ad1c0ce56c71'
AND (
token = '1nd3ESyJzYoW/wYvEMPXh1FHzK6/RgsE3m1w7atVrf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)