UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQkOLjZHZIPsZdIIXKlwx4hdEI3kOvV+HbLvtMKEB04='
WHERE
key_id = '6823a40bf60dcd5b66616494c3e2198095b00bdf1881f14df4831e789b4ba39c'
AND (
token = 'zQkOLjZHZIPsZdIIXKlwx4hdEI3kOvV+HbLvtMKEB04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)