UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7cDLOMfXcV8zOqLImsHT8XC6/sPaGasBmL2jfUe/HZI='
WHERE
key_id = 'ccb8ad390f7e381776949b11245d76362ec259ba74aeffbf22844ab07dc204b4'
AND (
token = '7cDLOMfXcV8zOqLImsHT8XC6/sPaGasBmL2jfUe/HZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)