UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xrj4GGwfGs7VeLG4AzCIFJlppTFDd0Nh1rL3dPNeID4='
WHERE
key_id = '4d3cb66772d8a8436200ad2b066c77639e8a22c397837891479350c2648b94b4'
AND (
token = 'Xrj4GGwfGs7VeLG4AzCIFJlppTFDd0Nh1rL3dPNeID4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)