UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7O0aMvdbwyr9HajPHRZY9zBMptO8+Csm/iYCxRSDYbs='
WHERE
key_id = '00ae92ece6b80d2c592bcae15b93e16a8618a66559669d1368cbf8f627f242f6'
AND (
token = '7O0aMvdbwyr9HajPHRZY9zBMptO8+Csm/iYCxRSDYbs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)