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