UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dpUUEshj+hKREVWgOYtmMlMN/lWxSLLeOqTGaHQ6j9Q='
WHERE
key_id = '818ac6c9494e1fbe8e743a7c22ae27be9ad7b1e68ef4385398b73f67a8edf471'
AND (
token = 'dpUUEshj+hKREVWgOYtmMlMN/lWxSLLeOqTGaHQ6j9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)