UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UP8t0ggoikMMQ6KmrE8rN+uxSbrX+H2D5nPCDuBa65U='
WHERE
key_id = '65c03be68d5c133c2e9436f97bcefe2ea45ecde8e3a2b0205a066905cdb195ef'
AND (
token = 'UP8t0ggoikMMQ6KmrE8rN+uxSbrX+H2D5nPCDuBa65U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)