UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QgJHdBx/HrE4eNfw18uVjXLB9k0L20A48C75acsvYN4='
WHERE
key_id = '7ec76ca4803c29f25d72389eeda0ddf60f2b4fbc0ded5ef3e9debc7814d66fe7'
AND (
token = 'QgJHdBx/HrE4eNfw18uVjXLB9k0L20A48C75acsvYN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)