UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NVz8XoBNC+1BGKDwU7uwZDirWzQXSXgogFIoUnodW9Y='
WHERE
key_id = 'd8870ead4249fc3047e9132536a2beb54529eac41a350a95eaa67e3a01ab1a74'
AND (
token = 'NVz8XoBNC+1BGKDwU7uwZDirWzQXSXgogFIoUnodW9Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)