UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VRd9JLzFdQoH0bDEI+sd4pN/8U+AGSncdcepdxIuzKA='
WHERE
key_id = '1b365927da1ba44011f04235f1065a959b2cdd11b0e87629be372f5a889ef3a9'
AND (
token = 'VRd9JLzFdQoH0bDEI+sd4pN/8U+AGSncdcepdxIuzKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)