UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gL6HocazjUlFIf6tslW2VY45ybu5fRWObXjI32OlNwE='
WHERE
key_id = '48e6a757b37337e085cea11ecec88552013de372e9eea283639f34f1c5f7e8bc'
AND (
token = 'gL6HocazjUlFIf6tslW2VY45ybu5fRWObXjI32OlNwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)